informix trim

In Linux/Unix, some programs are command-line or service programs. Generally, there is a configuration file to describe their running rules. These rules are usually stored in the database, maintained by other applications. This involves a question:

Copy Code code as follows: #include #include #include #include $struct _db_person { Char name[30+1]; Char card[12+1]; int age; }; Char *trim (char *str) { Char *p, *buffer; int Len; if (NULL!=STR) { len = strlen (str);

Source: http://dev.csdn.net/article/60/60822.shtm Detailed usage of Informix SQL Functions I. Internal functions1. Internal Aggregate functions1) count (*) returns the number of rows2) count (distinct colname) returns the number of unique values in

--field and field type codes in a tableSELECT C.colname, C.coltype,t.owner from syscolumns C, systables t WHERE c.tabid = t.tabid and t.tabname = ' Dm_plc_policy '--View Database temp table space usageSelect Pagesize,chksize,nfree from

I. Intrinsic functions1. Internal aggregate function1) Count (*) returns the number of rows2) Count (DISTINCT colname) returns the number of unique values in the specified column3) SUM (colname/expression) Returns the value of the specified column

Function Detailed usage of Informix SQL functions One, internal functions 1. Internal aggregate function 1) Count (*) returns the number of rows 2 count (DISTINCT colname) returns the number of unique values in the specified column 3) SUM

Detailed articles on select, showing raw data, SQL, query results, and how SQL should be written under different databases.Https://en.wikipedia.org/wiki/Select_ (SQL)The directory is as follows:Contents [Hide]1Examples2limiting result

Recently with DB2, the difference between the database is still very large, a lot of functions are not the same1. Go to Space*DB2: Ltrim () is to go to the left space, RTrim () is to go to the right space.*informix: Trim () is the space to go.Usage:

PHP Function Index 967 functions A total of 967 functions Abs: Get absolute value. Acos: Gets the inverse cosine value. Ada_afetch: Gets the return column of the database. Ada_autocommit: Switch automatic change function. Ada_close: Close Adabas D

Source Text Address: http://blog.csdn.net/like_zhz/article/details/5441946Different relational models of DBI and DBD:##########################################################################The portable DBI Method:Connect establishes a connection